from sqlalchemy import Column, Integer, String, Float, DateTime
from sqlalchemy.schema import Identity
from app.database import Base

class StabilizedSoil(Base):
    __tablename__ = "stabilized_soil"
    id = Column(Integer, Identity(), primary_key=True)
    source = Column(String(50), nullable=False)
    mp_num = Column(String(50), nullable=False)
    col_time = Column(String(50), nullable=False)
    remark_1 = Column(String(50), nullable=False)
    is_p = Column(Integer, nullable=False)
    formula = Column(String(50), nullable=False)
    discharge_time = Column(String(50), nullable=False)
    
    # 实际质量
    stone_1 = Column(Float, nullable=False)
    stone_2 = Column(Float, nullable=False)
    stone_3 = Column(Float, nullable=False)
    stone_4 = Column(Float, nullable=False)
    stone_5 = Column(Float, nullable=False)
    stone_6 = Column(Float, nullable=False)
    stone_7 = Column(Float, nullable=False)
    fl_1 = Column(Float, nullable=False)
    fl_2 = Column(Float, nullable=False)
    fl_3 = Column(Float, nullable=False)
    water = Column(Float, nullable=False)
    s_total = Column(Float, nullable=False)
    
    # 理论质量
    th_stone_1 = Column(Float, nullable=False)
    th_stone_2 = Column(Float, nullable=False)
    th_stone_3 = Column(Float, nullable=False)
    th_stone_4 = Column(Float, nullable=False)
    th_stone_5 = Column(Float, nullable=False)
    th_stone_6 = Column(Float, nullable=False)
    th_stone_7 = Column(Float, nullable=False)
    th_fl_1 = Column(Float, nullable=False)
    th_fl_2 = Column(Float, nullable=False)
    th_fl_3 = Column(Float, nullable=False)
    th_water = Column(Float, nullable=False)
    
    # 可选字段
    remark_2 = Column(String(50))
    remark_3 = Column(String(50))
    baocunshijian = Column(String(50))
    biaoshi = Column(String(50)) 